<!DOCTYPE html>
<html>
<head><meta name="generator" content="Hexo 3.8.0">
  <meta charset="utf-8">
  
  <title>Mysql笔记：数据类型 | gdme1320 的笔记</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta name="description" content="Table of Contents   MySql时间类型：DATETIME &amp;amp; TIMESTAMP  长度 时区 JDBC表示时间的类型 其他命令  get current time\_zone         MySql时间类型：DATETIME &amp;amp; TIMESTAMP    长度   DATETIME类型包含DATE和TIME，范围1000-01-01 00:00:00">
<meta property="og:type" content="article">
<meta property="og:title" content="Mysql笔记：数据类型">
<meta property="og:url" content="http://gdme1320.gitee.com/mysql/datatype/index.html">
<meta property="og:site_name" content="gdme1320 的笔记">
<meta property="og:description" content="Table of Contents   MySql时间类型：DATETIME &amp;amp; TIMESTAMP  长度 时区 JDBC表示时间的类型 其他命令  get current time\_zone         MySql时间类型：DATETIME &amp;amp; TIMESTAMP    长度   DATETIME类型包含DATE和TIME，范围1000-01-01 00:00:00">
<meta property="og:locale" content="default">
<meta property="og:updated_time" content="2022-03-23T09:58:58.151Z">
<meta name="twitter:card" content="summary">
<meta name="twitter:title" content="Mysql笔记：数据类型">
<meta name="twitter:description" content="Table of Contents   MySql时间类型：DATETIME &amp;amp; TIMESTAMP  长度 时区 JDBC表示时间的类型 其他命令  get current time\_zone         MySql时间类型：DATETIME &amp;amp; TIMESTAMP    长度   DATETIME类型包含DATE和TIME，范围1000-01-01 00:00:00">
  
    <link rel="alternate" href="/atom.xml" title="gdme1320 的笔记" type="application/atom+xml">
  
  
  
    <link href="//fonts.googleapis.com/css?family=Source+Code+Pro" rel="stylesheet" type="text/css">
  

  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">

  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css" integrity="sha384-XdYbMnZ/QjLh6iI4ogqCTaIjrFk87ip+ekIjefZch0Y+PvJ8CDYtEs1ipDmPorQ+" crossorigin="anonymous">

  <link rel="stylesheet" href="/css/styles.css">
  <link rel="stylesheet" href="/css/docs.min.css">
  

</head>
</html>
<body>
  <nav class="navbar navbar-inverse">
  <div class="container">
    <!-- Brand and toggle get grouped for better mobile display -->
    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#main-menu-navbar" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
      
    </div>

    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="main-menu-navbar">
      <ul class="nav navbar-nav">
        
          <li><a class href="/index.html">Home</a></li>
        
          <li><a class href="/archives/">Archives</a></li>
        
      </ul>

      <!--
      <ul class="nav navbar-nav navbar-right">
        
          <li><a href="/atom.xml" title="RSS Feed"><i class="fa fa-rss"></i></a></li>
        
      </ul>
      -->
    </div><!-- /.navbar-collapse -->
  </div><!-- /.container-fluid -->
</nav>

  <div class="container bs-docs-container">
  
    <div class="row">
        <div class="col-sm-8 blog-main">
          <article id="post-mysql/datatype" class="article article-type-post" itemscope itemprop="blogPost">

  <header class="article-header">
    
  
    <h1 class="article-title" itemprop="name">
      Mysql笔记：数据类型
    </h1>
  


  </header>

  <div class="article-meta">
    <div class="article-datetime">
  <a href="/mysql/datatype/" class="article-date"><time datetime="1970-01-01T00:00:02.018Z" itemprop="datePublished">1970-01-01</time></a>
</div>

    
    
  <div class="article-category">
    <a class="article-category-link" href="/categories/mysql/">mysql</a>
  </div>


  </div>
  <div class="article-inner">

    <div class="article-entry" itemprop="articleBody">
      
        
<div id="content">
<div id="table-of-contents">
<h2>Table of Contents</h2>
<div id="text-table-of-contents">
<ul>
<li><a href="#orge440786">MySql时间类型：DATETIME &amp; TIMESTAMP</a>
<ul>
<li><a href="#orge9b84fa">长度</a></li>
<li><a href="#orgc41ce42">时区</a></li>
<li><a href="#org0ef6595">JDBC表示时间的类型</a></li>
<li><a href="#org439bf3f">其他命令</a>
<ul>
<li><a href="#org18603da">get current time\_zone</a></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<div class="outline-2" id="outline-container-orge440786">
<h2 id="orge440786">MySql时间类型：DATETIME &amp; TIMESTAMP</h2>
<div class="outline-text-2" id="text-orge440786">
</div>
<div class="outline-3" id="outline-container-orge9b84fa">
<h3 id="orge9b84fa">长度</h3>
<div class="outline-text-3" id="text-orge9b84fa">
<ul class="org-ul">
<li>DATETIME类型包含DATE和TIME，范围1000-01-01 00:00:00 ~ 9999-12-31 23:59:59。DATETIME还能包含毫秒，例如2018-03-11 14::13:22.999</li>
<li>TIMESTAMP也能存储日期和时间，但是范围只有1970-01-01 00:00:01 UTC ~ 2038-01-19 03:14:07 UT</li>
</ul>
</div>
</div>
<div class="outline-3" id="outline-container-orgc41ce42">
<h3 id="orgc41ce42">时区</h3>
<div class="outline-text-3" id="text-orgc41ce42">
<ul class="org-ul">
<li>DATETIME存储的时间不包含时区</li>
<li>TIMESTAMP存储的UTC时间</li>
</ul>
<p>
例如：
</p>
<ol class="org-ol">
<li>Create table</li>
</ol>
<pre class="example">
CREATE TABLE timestamp_n_datetime (
    id INT AUTO_INCREMENT PRIMARY KEY,
    ts TIMESTAMP,
    dt DATETIME
);
</pre>
<ol class="org-ol">
<li>insert now（当前时区为+08）</li>
</ol>
<div class="org-src-container">
<pre class="src src-sql"><span style="font-weight: bold;">insert</span> <span style="font-weight: bold;">into</span> timestamp_n_datetime(ts,dt) <span style="font-weight: bold;">values</span> (now(), now());
</pre>
</div>
<p>
Select result:
</p>
<p>
MariaDB [test]&gt; select * from timestamp_n_datetime;
</p>
<!-- This HTML table template is generated by emacs 26.3 -->
<table border="1">
<tr>
<td align="left" valign="top">
       id 
    </td>
<td align="left" valign="top">
       ts                  
    </td>
<td align="left" valign="top">
       dt                  
    </td>
</tr>
<tr>
<td align="left" valign="top">
        1 
    </td>
<td align="left" valign="top">
       2018-03-11 14:35:01 
    </td>
<td align="left" valign="top">
       2018-03-11 14:35:01 
    </td>
</tr>
</table>
<p>
1 row in set (0.00 sec)
</p>
<ol class="org-ol">
<li><p>
修改时区
</p>
<p>
MariaDB [test]&gt; set time_zone = '+00:00';
Query OK, 0 rows affected (0.02 sec)
</p></li>
<li><p>
再次查询
</p>
<p>
MariaDB [test]&gt; select * from timestamp_n_datetime;
</p>
<!-- This HTML table template is generated by emacs 26.3 -->
<table border="1">
<tr>
<td align="left" valign="top">
       id 
    </td>
<td align="left" valign="top">
       ts                  
    </td>
<td align="left" valign="top">
       dt                  
    </td>
</tr>
<tr>
<td align="left" valign="top">
        1 
    </td>
<td align="left" valign="top">
       2018-03-11 06:35:01 
    </td>
<td align="left" valign="top">
       2018-03-11 14:35:01 
    </td>
</tr>
</table>
<p>
1 row in set (0.00 sec)
</p></li>
</ol>
<p>
TIMESTAMP存储的时间调整到了新时区，而DATETIME存储的时间不变。刚接触java的时候写代码的就出现过时区问题，mybatis mysql，表字段类型为DATETIME，java类型为java.util.Date。通过查看java connector源码com.mysql.cj.mysqla.MysqlaSession.java的configureTimezone方法，
</p>
<div class="org-src-container">
<pre class="src src-java"><span style="font-weight: bold;">this</span>.getServerVariable(<span style="font-style: italic;">"system_time_zone"</span>)
</pre>
</div>
<p>
调试这里发现从系统里面读出来的时区设置是CST。于是去查找数据库服务器的原因
</p>
<p>
MariaDB [(none)]&gt; show variables like '%time_zone%';
</p>
<!-- This HTML table template is generated by emacs 26.3 -->
<table border="1">
<tr>
<td align="left" valign="top">
       Variable_name    
    </td>
<td align="left" valign="top">
       Value  
    </td>
</tr>
<tr>
<td align="left" valign="top">
       system_time_zone <br>
       time_zone        
    </td>
<td align="left" valign="top">
       CST    <br>
       SYSTEM 
    </td>
</tr>
</table>
<p>
2 rows in set (0.01 sec)
</p>
<p>
解决方法：
</p>
<p>
修改配置文件 /etc/my.cnf.d/server.cnf (centos 7)，需要重启mysql
</p>
<div class="org-src-container">
<pre class="src src-conf"><span style="font-weight: bold; font-style: italic;"># </span><span style="font-weight: bold; font-style: italic;">this is only for the mysqld standalone daemon</span>
[<span style="font-weight: bold; text-decoration: underline;">mysqld</span>]
<span style="font-weight: bold; font-style: italic;">default-time-zone</span>=<span style="font-style: italic;">'+08:00'</span> <span style="font-weight: bold; font-style: italic;"># </span><span style="font-weight: bold; font-style: italic;">将这行加到mysqld节点下</span>
</pre>
</div>
<p>
修改数据库服务变量（未验证，如果不方便修改配置文件或重启数据库。重启数据库之后失效？？）
</p>
<div class="org-src-container">
<pre class="src src-sql"><span style="font-weight: bold;">set</span> time_zone=<span style="font-style: italic;">'+08:00'</span>;
<span style="font-weight: bold;">set</span> <span style="font-weight: bold;">global</span> time_zone=<span style="font-style: italic;">'+08:00'</span>;
flush <span style="font-weight: bold;">privileges</span>;
</pre>
</div>
<p>
如果是直接使用jdbc而不是mybatis，则通过
</p>
<div class="org-src-container">
<pre class="src src-java"><span style="font-weight: bold; text-decoration: underline;">java</span>.<span style="font-weight: bold; text-decoration: underline;">util</span>.<span style="font-weight: bold; text-decoration: underline;">Date</span> <span style="font-weight: bold; font-style: italic;">now</span> = <span style="font-weight: bold;">new</span> <span style="font-weight: bold; text-decoration: underline;">java</span>.<span style="font-weight: bold; text-decoration: underline;">util</span>.<span style="font-weight: bold; text-decoration: underline;">Date</span>();
<span style="font-weight: bold; text-decoration: underline;">java</span>.<span style="font-weight: bold; text-decoration: underline;">sql</span>.<span style="font-weight: bold; text-decoration: underline;">Timestamp</span> <span style="font-weight: bold; font-style: italic;">sqlTimestamp</span> = <span style="font-weight: bold;">new</span> <span style="font-weight: bold; text-decoration: underline;">java</span>.<span style="font-weight: bold; text-decoration: underline;">sql</span>.<span style="font-weight: bold; text-decoration: underline;">Timestamp</span>(now.getTime());
PreparedStatement.setTimestamp(1, sqlTimestamp, Calendar.getInstance(<span style="font-weight: bold; text-decoration: underline;">Locale</span>.CHINA)); 
</pre>
</div>
<p>
即指定第三个参数。如果没有指定第三个参数，则又使用了CST时间（setTimestamp源码中）
</p>
</div>
</div>
<div class="outline-3" id="outline-container-org0ef6595">
<h3 id="org0ef6595">JDBC表示时间的类型</h3>
<div class="outline-text-3" id="text-org0ef6595">
<p>
这一节的资料有点老（<a href="https://www.cis.upenn.edu/~bcpierce/courses/629/jdkdocs/guide/jdbc/getstart/mapping.doc.html" target="_blank" rel="noopener">https://www.cis.upenn.edu/~bcpierce/courses/629/jdkdocs/guide/jdbc/getstart/mapping.doc.html</a>）
</p>
<p>
这三种类型都继承自java.util.Date，因为java.util.Date没法匹配三种JDBC时间类型。
</p>
<ul class="org-ul">
<li>DATE表示只包含了年月日的时间类型 java.sql.Date for SQL DATE（这里的SQL说的是SQL-92标准）。 父类的hour, minute, second, millisecond字段被设置为0。</li>
<li>TIME表示只包含了时分秒的时间类型 java.sql.Time for SQL TIME information. 父类的year, month, day字段被设置为1970, 1月, 1号. 这个时间是java里面的“零纪元”</li>
<li>TIMESTAMP包含了DATE+TIME再加上一个纳秒（nanosecond）字段 java.sql.Timestamp for SQL TIMESTAMP information. 这个类型为java.util.Date扩展了额外的nanosecond字段。</li>
</ul>
</div>
</div>
<div class="outline-3" id="outline-container-org439bf3f">
<h3 id="org439bf3f">其他命令</h3>
<div class="outline-text-3" id="text-org439bf3f">
</div>
<div class="outline-4" id="outline-container-org18603da">
<h4 id="org18603da">get current time\_zone</h4>
<div class="outline-text-4" id="text-org18603da">
<div class="org-src-container">
<pre class="src src-sql"><span style="font-weight: bold;">SELECT</span> @@<span style="font-weight: bold;">global</span>.<span style="font-weight: bold; text-decoration: underline;">time</span>\_zone, @@<span style="font-weight: bold;">session</span>.<span style="font-weight: bold; text-decoration: underline;">time</span>\_zone;
</pre>
</div>
<p>
如果查询结果是SYSTEM，表示mysql服务器使用了系统时区  date -R  命令能查看系统时区。
</p>
</div>
</div>
</div>
</div>
</div>
<div class="status" id="postamble">
<p class="date">Date: 2018</p>
<p class="author">Author: gdme1320</p>
<p class="validation"><a href="http://validator.w3.org/check?uri=referer" target="_blank" rel="noopener">Validate</a></p>
</div>

      
    </div>

    
      

    

    <footer class="article-footer">
      <a data-url="http://gdme1320.gitee.com/mysql/datatype/" data-id="cl13eo7k1008mhjv4kgk5batq" class="article-share-link">
        <i class="fa fa-share"></i> Share
      </a>
      
      

    </footer>
  </div>
  
    
<ul id="article-nav" class="nav nav-pills nav-justified">
  
  <li role="presentation">
    <a href="/vim/index/" id="article-nav-older" class="article-nav-link-wrap">
      <i class="fa fa-chevron-left pull-left"></i>
      <span class="article-nav-link-title">Vim Yes</span>
    </a>
  </li>
  
  
  <li role="presentation">
    <a href="/dotnet/lambda-expr-tree-test/" id="article-nav-newer" class="article-nav-link-wrap">
      <span class="article-nav-link-title">C# Lambda Expression Tree 测试</span>
      <i class="fa fa-chevron-right pull-right"></i>
    </a>
  </li>
  
</ul>


  
</article>




        </div>
        <div class="col-sm-3 col-sm-offset-1 blog-sidebar">
          
  
  <div class="sidebar-module">
    <h4>Categories</h4>
    <ul class="sidebar-module-list"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/apps/">apps</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/architecture/">architecture</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/devops/">devops</a><span class="sidebar-module-list-count">10</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/devops/kubectl/">kubectl</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/devops/kubernetes/">kubernetes</a><span class="sidebar-module-list-count">3</span></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/dotnet/">dotnet</a><span class="sidebar-module-list-count">3</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/dotnet/entityframework/">entityframework</a><span class="sidebar-module-list-count">1</span></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/elasticsearch/">elasticsearch</a><span class="sidebar-module-list-count">4</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/emacs/">emacs</a><span class="sidebar-module-list-count">4</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/emacs/org-mode/">org-mode</a><span class="sidebar-module-list-count">3</span></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/git/">git</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/graphql/">graphql</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/groovy/">groovy</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/">java</a><span class="sidebar-module-list-count">52</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/concurrent/">concurrent</a><span class="sidebar-module-list-count">4</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/jackson/">jackson</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/shiro/">shiro</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/spring/">spring</a><span class="sidebar-module-list-count">11</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/spring-amqp/">spring-amqp</a><span class="sidebar-module-list-count">5</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/spring-amqp/spring-jpa/">spring-jpa</a><span class="sidebar-module-list-count">1</span></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/spring-jpa/">spring-jpa</a><span class="sidebar-module-list-count">10</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/spring-security/">spring-security</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/thymeleaf/">thymeleaf</a><span class="sidebar-module-list-count">2</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/java/thymeleaf/maven/">maven</a><span class="sidebar-module-list-count">1</span></li></ul></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/jenkins/">jenkins</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/journal/">journal</a><span class="sidebar-module-list-count">7</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/js/">js</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/linux/">linux</a><span class="sidebar-module-list-count">35</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/linux/kde/">kde</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/linux/kross/">kross</a><span class="sidebar-module-list-count">3</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/linux/kross/ktorrent-scripts/">ktorrent-scripts</a><span class="sidebar-module-list-count">1</span></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/linux/shell/">shell</a><span class="sidebar-module-list-count">6</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/linux/tcp/">tcp</a><span class="sidebar-module-list-count">1</span></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/lisp/">lisp</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/mongodb/">mongodb</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/mssql/">mssql</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/mysql/">mysql</a><span class="sidebar-module-list-count">12</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/nginx/">nginx</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/node/">node</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/postgresql/">postgresql</a><span class="sidebar-module-list-count">2</span><ul class="sidebar-module-list-child"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/postgresql/client/">client</a><span class="sidebar-module-list-count">1</span></li></ul></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/python/">python</a><span class="sidebar-module-list-count">19</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/regex/">regex</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/rfc/">rfc</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/vim/">vim</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/categories/windows/">windows</a><span class="sidebar-module-list-count">7</span></li></ul>
  </div>



  
  <div class="sidebar-module">
    <h4>Tags</h4>
    <ul class="sidebar-module-list"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/tags/ReentrantLock/">ReentrantLock</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/tags/nohup/">nohup</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/tags/pandoc/">pandoc</a><span class="sidebar-module-list-count">1</span></li></ul>
  </div>



  
  <div class="sidebar-module">
    <h4>Tag Cloud</h4>
    <p class="tagcloud">
      <a href="/tags/ReentrantLock/" style="font-size: 10px;">ReentrantLock</a> <a href="/tags/nohup/" style="font-size: 10px;">nohup</a> <a href="/tags/pandoc/" style="font-size: 10px;">pandoc</a>
    </p>
  </div>


  
  <div class="sidebar-module">
    <h4>Archives</h4>
    <ul class="sidebar-module-list"><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2919/06/">June 2919</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2022/03/">March 2022</a><span class="sidebar-module-list-count">58</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2022/01/">January 2022</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2021/11/">November 2021</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2021/10/">October 2021</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2021/04/">April 2021</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2021/03/">March 2021</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2021/02/">February 2021</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2021/01/">January 2021</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/12/">December 2020</a><span class="sidebar-module-list-count">2</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/11/">November 2020</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/10/">October 2020</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/09/">September 2020</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/07/">July 2020</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/06/">June 2020</a><span class="sidebar-module-list-count">10</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/04/">April 2020</a><span class="sidebar-module-list-count">4</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/03/">March 2020</a><span class="sidebar-module-list-count">8</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/02/">February 2020</a><span class="sidebar-module-list-count">4</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2020/01/">January 2020</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/12/">December 2019</a><span class="sidebar-module-list-count">7</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/11/">November 2019</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/10/">October 2019</a><span class="sidebar-module-list-count">11</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/09/">September 2019</a><span class="sidebar-module-list-count">6</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/08/">August 2019</a><span class="sidebar-module-list-count">4</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/07/">July 2019</a><span class="sidebar-module-list-count">10</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/06/">June 2019</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/05/">May 2019</a><span class="sidebar-module-list-count">3</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/04/">April 2019</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/03/">March 2019</a><span class="sidebar-module-list-count">8</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/02/">February 2019</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2019/01/">January 2019</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2018/11/">November 2018</a><span class="sidebar-module-list-count">4</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2018/10/">October 2018</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2018/08/">August 2018</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2018/07/">July 2018</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2018/06/">June 2018</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2018/03/">March 2018</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2017/07/">July 2017</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2017/06/">June 2017</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2017/04/">April 2017</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/2015/05/">May 2015</a><span class="sidebar-module-list-count">1</span></li><li class="sidebar-module-list-item"><a class="sidebar-module-list-link" href="/archives/1970/01/">January 1970</a><span class="sidebar-module-list-count">9</span></li></ul>
  </div>



  
  <div class="sidebar-module">
    <h4>Recents</h4>
    <ul class="sidebar-module-list">
      
        <li>
          <a href="/java/acessing-generic-types-at-runtime/">获取泛型类型</a>
        </li>
      
        <li>
          <a href="/linux/shell/bash_cgi/">Script for Shell Parsing Parameters</a>
        </li>
      
        <li>
          <a href="/linux/shell/shell-script/">Shell Script Getting Start</a>
        </li>
      
        <li>
          <a href="/linux/tcp/network-tcp-performance-turning-with-sysctl/">【翻译】Sysctl调节Linux网络性能</a>
        </li>
      
        <li>
          <a href="/java/concurrent/aqs-src/">AQS源码笔记</a>
        </li>
      
    </ul>
  </div>



        </div>
    </div>
  </div>
  <footer class="blog-footer">
  <div class="container">
    <div id="footer-info" class="inner">
      &copy; 2022 gdme1320<br>
      Powered by <a href="http://hexo.io/" target="_blank">Hexo</a>
    </div>
  </div>
</footer>

  

<!-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js" integrity="sha384-8gBf6Y4YYq7Jx97PIqmTwLPin4hxIzQw5aDmUg/DDhul9fFpbbLcLh3nTIIDJKhx" crossorigin="anonymous"></script> -->

<script src="/js/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" integrity="sha384-0mSbJDEHialfmuBBQP6A4Qrprq5OVfW37PRR3j5ELqxss1yVqOtnepnHVP9aJ7xS" crossorigin="anonymous"></script>



<script src="/js/script.js"></script>

</body>
</html>
